UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BnDEZS3WlRSOZoQUWWwXdxWTTof967aHYwj8JDEUPuo='
WHERE
key_id = '4f8a5d4ca3ac4300ea256ed20a156090c0c7cad05ca4d71901fdb0b6a39f6678'
AND (
token = 'BnDEZS3WlRSOZoQUWWwXdxWTTof967aHYwj8JDEUPuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)