UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1GXswEag33GY/OF2WzJq0COCjKlDGCNADats329ooc='
WHERE
key_id = '8cf254de3a9eff7cd2f3fdd25e1b1e3cc25404cc98baf94f05c85253dda66fef'
AND (
token = '/1GXswEag33GY/OF2WzJq0COCjKlDGCNADats329ooc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)