UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nRQk+CSbW0atTOJZnacWZ57amhrhWR2Xb2ydww26mPQ='
WHERE
key_id = 'a4e8763d030072ccb7d779a60ffd5540b19935f5b1a357aee9a07d543203eddd'
AND (
token = 'nRQk+CSbW0atTOJZnacWZ57amhrhWR2Xb2ydww26mPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)