UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lOjXYASWhi5kgzJMo3RaID5txnWS7IFWmhb5eKcHptU='
WHERE
key_id = '80f28ba63fba23d5c4d0543e0176b76a087030fadae766e7952fb28e9105d3f2'
AND (
token = 'lOjXYASWhi5kgzJMo3RaID5txnWS7IFWmhb5eKcHptU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)