UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bNZfbJcO4ABzycgFGfyKET78AMiEPKjHh3bCVlXGzqo='
WHERE
key_id = '5d904f620c2170566025850e90a1a2efbe84806dd05d53973efb0f8b3c230410'
AND (
token = 'bNZfbJcO4ABzycgFGfyKET78AMiEPKjHh3bCVlXGzqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)