UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B8wZiOYa3Z7El9UcnhLy8SVmbqGsKS9yGoefGt05u4w='
WHERE
key_id = '32cddef0b12c25184771a180c36139fc1cc8f292015115906a312eca9fc58d2a'
AND (
token = 'B8wZiOYa3Z7El9UcnhLy8SVmbqGsKS9yGoefGt05u4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)