UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'du+Y7v29+eiOfXCPoP4Y6u3STqI5G7cbgTY5xmIQk4A='
WHERE
key_id = 'b0dedb86647c2ba18d00e828080a924ddfe5cbb2992839fbde801584013d9d56'
AND (
token = 'du+Y7v29+eiOfXCPoP4Y6u3STqI5G7cbgTY5xmIQk4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)