UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LqjGaKwJrUsIL7ICuHOjc5SQiYk8PcbLOhEDSuAXik8='
WHERE
key_id = '174c6bd47af3394859c88f11f209dcb7d9a20439fba384b1a2d8ae626c137cd0'
AND (
token = 'LqjGaKwJrUsIL7ICuHOjc5SQiYk8PcbLOhEDSuAXik8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)