UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LJLTgP6ZNUo4dZrXVCoReQi9cVV/cmS6miA/UEsueZk='
WHERE
key_id = 'bfaa8b5f640fff53d4e2f6007fa85c1cbd73af0f318c2d472a12cbb0a6018e38'
AND (
token = 'LJLTgP6ZNUo4dZrXVCoReQi9cVV/cmS6miA/UEsueZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)