UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaGU2ES/ZeN5g7g+JmrSSkqm5XjLKoqMBnyphDxETzo='
WHERE
key_id = 'f6e8e9ad6f8284a0a7ebd3cb7d01d831d99f5b99a750b46a90312359d2c28c70'
AND (
token = 'zaGU2ES/ZeN5g7g+JmrSSkqm5XjLKoqMBnyphDxETzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)