UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cjVHhWETK5IoUOZivh8pJ9c216mwKM47P7X0xCION/Q='
WHERE
key_id = 'a938d930952f42096913c46a40b0b52fbda4d690f6c32e0571b5ac32fef3ec97'
AND (
token = 'cjVHhWETK5IoUOZivh8pJ9c216mwKM47P7X0xCION/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)