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