UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEQB62ztAbd8stwsVfJAJb49kDpRhc2UKcVIVUAytI8='
WHERE
key_id = '83404d2f5122461602e61d963887d26c2674ddda631277b744348c973f3014dd'
AND (
token = 'xEQB62ztAbd8stwsVfJAJb49kDpRhc2UKcVIVUAytI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)