UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EHdnHd2b4s0i7D4Zt59aPjFLbJmUeQPf1oCXNKPIpM='
WHERE
key_id = 'cce9e2cfa347c1f75880490ba109cfd0c79842ca46ebb6f86257e0ffb7fdb782'
AND (
token = '8EHdnHd2b4s0i7D4Zt59aPjFLbJmUeQPf1oCXNKPIpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)