UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v8Z0PysQedDxjwXvYNq5ZbIq3HvZQfykKjrtOl8RhBM='
WHERE
key_id = '0f07336e5af667f9f7756b35f9c574e2fe3fbcde9e4c05221b4b797a905be52f'
AND (
token = 'v8Z0PysQedDxjwXvYNq5ZbIq3HvZQfykKjrtOl8RhBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)