UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvMRS7hXfRPRPqTLGtHoEGI6iak+P90Gxkk+Gm6dti4='
WHERE
key_id = 'e31d3f734be2b096ed35319d31cf5adecfba446b48c092690f9fb25664fd1edd'
AND (
token = 'HvMRS7hXfRPRPqTLGtHoEGI6iak+P90Gxkk+Gm6dti4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)