UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ip4ahOxfG0HNHB8ToAP2ZgS7qtQTA+CF87VqEpRmAE='
WHERE
key_id = '1a37d6de55cf24901c4584a5da295e232708cb4236c546be3b9893c4b08aa8fd'
AND (
token = '6ip4ahOxfG0HNHB8ToAP2ZgS7qtQTA+CF87VqEpRmAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)