UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TcqNv708ouX8Y3M2f1HsMicV7PW0dgJAhqv8v1XQtA='
WHERE
key_id = 'bc91b8e35e6f0f81859a90f2ef6a3f4640b324dc590e980811c5fb430d8f7429'
AND (
token = '8TcqNv708ouX8Y3M2f1HsMicV7PW0dgJAhqv8v1XQtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)