UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LPwoIvW9XQSzkvxaiVeweNL7tui+7MuCxKikpXveYU='
WHERE
key_id = 'e43d68252dffc8a1792a5737fc162db50f72534928280c6b569ecdab1d1ac31c'
AND (
token = '4LPwoIvW9XQSzkvxaiVeweNL7tui+7MuCxKikpXveYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)