UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qvsXMwCpSq5Tlp27jGs36/E2BO5/Yn6W2n0Z2Ajo5K8='
WHERE
key_id = 'c109c8046c59c6fb6b2ccd146971b8067334c3f1ba7bd415c5f99364ef0f6f8c'
AND (
token = 'qvsXMwCpSq5Tlp27jGs36/E2BO5/Yn6W2n0Z2Ajo5K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)