UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqtyIt+PHLH2WyhBwbWnqmhHVka+LX8x1xkS5e9XStI='
WHERE
key_id = '6c163d43f0adbf3485f5ad3638a0f97ad6145651cf5f29ccce4bd969ad409e7f'
AND (
token = 'XqtyIt+PHLH2WyhBwbWnqmhHVka+LX8x1xkS5e9XStI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)