UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1WbNjgNj6Un3b+XstBSA+muN9wLE1a7eUWz2opANEw='
WHERE
key_id = 'fce12396ff9fcd8dd36b3580d076a9b3cf15a65359b913b0870528ab5430ebb4'
AND (
token = 'N1WbNjgNj6Un3b+XstBSA+muN9wLE1a7eUWz2opANEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)