UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k8WO9XfX4Sa3mm9HgWwKsGm6xyzNtgDYZItDC9+1DBM='
WHERE
key_id = 'ae2f50282c72d0843d5352e63bde82f7a5306e42851ed6ea449fcda0294574f5'
AND (
token = 'k8WO9XfX4Sa3mm9HgWwKsGm6xyzNtgDYZItDC9+1DBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)