UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yV0NvHxgleUwn5tSU3GpgdGCbrpF88LEl3Eqj19VdR0='
WHERE
key_id = '26d7c8c1d5bef4fa97e64469bf098a906f6b5ae1e88ee8b7f7985839f3ec4edf'
AND (
token = 'yV0NvHxgleUwn5tSU3GpgdGCbrpF88LEl3Eqj19VdR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)