UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TPCcn+no3mHSf46QHHzIUDQV/39hH+Rt+KnXi8iz4X0='
WHERE
key_id = '7d149500f53299e6646ab1f131f4c81c3ff3ca6ca54e6f890a1a4586072a0ab6'
AND (
token = 'TPCcn+no3mHSf46QHHzIUDQV/39hH+Rt+KnXi8iz4X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)