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