UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c9J21McZgejCcDhcg3CUH38VCCB01z/gIXCy2MIBmJ0='
WHERE
key_id = '70dd8a65dbfc80d42c6cdae18051ad2279468a1db8671e6d77904933443e4a2e'
AND (
token = 'c9J21McZgejCcDhcg3CUH38VCCB01z/gIXCy2MIBmJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)