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