UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lb07JRrjfWZ4FGtfehKAIJrKlamYTa67p1VDUx7V5fU='
WHERE
key_id = 'be1da05494d18aa7e0dc1478e517227927537731c9aae702d4d8944ac902a099'
AND (
token = 'Lb07JRrjfWZ4FGtfehKAIJrKlamYTa67p1VDUx7V5fU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)