UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YUYNgvN7FDC8HK6r5YUGMTdNSkSYYptLDiBjmw2Nc38='
WHERE
key_id = 'ec1221dbdd9d8c4cd439dcb3a3cb7fdecb13b798223d26d973cb9a620bd358c1'
AND (
token = 'YUYNgvN7FDC8HK6r5YUGMTdNSkSYYptLDiBjmw2Nc38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)