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