UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's79XZK3GIN6Cl84R/eGchhVhQzd1pmV4G/m/NrJr0Xk='
WHERE
key_id = '50d253b4e69763a85379a8a57dae8417e20d15e2b6ddaa32d9b8447ff7f2b2ba'
AND (
token = 's79XZK3GIN6Cl84R/eGchhVhQzd1pmV4G/m/NrJr0Xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)