UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJCzFagqvkRB14wbA177ls8Qc2yxCTQXae273CH4NBk='
WHERE
key_id = '266db1a978eee91382948e1a2c54f11c8eebee25274891745530daceab339e5a'
AND (
token = 'BJCzFagqvkRB14wbA177ls8Qc2yxCTQXae273CH4NBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)