UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wrQxdHS51SJnxMmWVYSXxrqBDw1014I5B4/92OMGdWY='
WHERE
key_id = 'a83cb31667bafb16505a1eafe79a3335fa806d5364b7fd58f1b419f6791cd102'
AND (
token = 'wrQxdHS51SJnxMmWVYSXxrqBDw1014I5B4/92OMGdWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)