UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lFlMaKwCipeC9HU63J0e5XLxnSjEuei1IWDa2ACPePI='
WHERE
key_id = '7ddbfccc7914be13334644129b5e27741c6a1348e1d432d61925c2bb4b2dd28a'
AND (
token = 'lFlMaKwCipeC9HU63J0e5XLxnSjEuei1IWDa2ACPePI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)